SELECT t.created_date FROM C1_ENTITY_LOG T WHERE t.code = :code AND EXISTS
(SELECT 1 FROM c1_dictionary e WHERE e.id = t.type_id AND e.code = :typeCode
)